#!/bin/bash

sqls[0]="drop table if exists dry_bank"
sqls[1]="drop table if exists dry_bank_4_element"
sqls[2]="drop table if exists dry_banner"
sqls[3]="drop table if exists dry_class"
sqls[4]="drop table if exists dry_demo"
sqls[5]="drop table if exists dry_document"
sqls[6]="drop table if exists dry_document_category"
sqls[7]="drop table if exists dry_download"
sqls[8]="drop table if exists dry_feedback"
sqls[9]="drop table if exists dry_mall_category"
sqls[10]="drop table if exists dry_news"
sqls[11]="drop table if exists dry_order"
sqls[12]="drop table if exists dry_php_configure"
sqls[13]="drop table if exists dry_product"
sqls[14]="drop table if exists dry_product_agent"
sqls[15]="drop table if exists dry_student"
sqls[16]="drop table if exists dry_system_task"
sqls[17]="drop table if exists dry_test"
sqls[18]="drop table if exists dry_user_account"
sqls[19]="drop table if exists dry_user_account_log"
sqls[20]="drop table if exists dry_user_bank"
sqls[21]="drop table if exists dry_user_income_log"
sqls[22]="drop table if exists dry_withdraw"
sqls[23]="delete from dry_user where id>5"
password='\$2y\$10\$SR5.ZlGF5a5T9UI7yIFtC.TNC3KymuCYEiccqeDPbPfKP8UTbsrCS'
sqls[24]="update dry_user set dry_phone=null,dry_email=null,dry_password='${password}'"
sqls[25]="truncate table dry_file_category"
sqls[26]="truncate table dry_file"
sqls[27]="truncate table dry_oss_file"
sqls[28]="truncate table dry_sub_user"
sqls[29]="truncate table dry_group_permission"
sqls[30]="delete from dry_model where id in (1,3,5,10,16,17,18,19,20,21,22,23,24,25)"
sqls[31]="delete from dry_model_field where dry_model in (1,3,5,10,16,17,18,19,20,21,22,23,24,25)"
sqls[32]="delete from dry_menu where id in (34,31,32,33,28,29,30,35,36,37,38,39,40,41,7,8,9,10,20,22)"